S2E Colombia
Endline Survey Refusal Analysis


Note: endline_refusal ==  if the the survey firm has confirmed that these firms do not wish to participate in the survey anymore 
endline_refusal == 0 are firms that have responded and firms who cases are still open. 

+--------------------------------------------------------------------------------+

Attrition Rate: Midline vs Endline: disaggregated by waves. 

tab wave_b endline_refusal, row   // endline_refusal == 1 if respondent refused at endline


           |    endline_refusal
    wave_b |         0          1 |     Total
-----------+----------------------+----------
         1 |       346         50 |       396 
           |     87.37      12.63 |    100.00 
-----------+----------------------+----------
         2 |       285         32 |       317 
           |     89.91      10.09 |    100.00 
-----------+----------------------+----------
         3 |       341         51 |       392 
           |     86.99      13.01 |    100.00 
-----------+----------------------+----------
     Total |       972        133 |     1,105 
           |     87.96      12.04 |    100.00 



tab wave_b notfoundatmid , row


           | Not found at midline
      wave |         0          1 |     Total
-----------+----------------------+----------
         1 |       230        166 |       396 
           |     58.08      41.92 |    100.00 
-----------+----------------------+----------
         2 |       214        103 |       317 
           |     67.51      32.49 |    100.00 
-----------+----------------------+----------
         3 |       271        121 |       392 
           |     69.13      30.87 |    100.00 
-----------+----------------------+----------
     Total |       715        390 |     1,105 
           |     64.71      35.29 |    100.00 



+--------------------------------------------------------------------------------+

Comparison between those not found at midline and those refused at endline: 

tab notfoundatmid endline_refusal, column


 Not found |    endline_refusal
at midline |         0          1 |     Total
-----------+----------------------+----------
         0 |       659         56 |       715 
           |     67.80      42.11 |     64.71 
-----------+----------------------+----------
         1 |       313         77 |       390 
           |     32.20      57.89 |     35.29 
-----------+----------------------+----------
     Total |       972        133 |     1,105 
           |    100.00     100.00 |    100.00 


+--------------------------------------------------------------------------------+



tab wave_b notfoundatmid if endline_refusal == 1, row

           | Not found at midline
      wave |         0          1 |     Total
-----------+----------------------+----------
         1 |        21         29 |        50 
           |     42.00      58.00 |    100.00 
-----------+----------------------+----------
         2 |        14         18 |        32 
           |     43.75      56.25 |    100.00 
-----------+----------------------+----------
         3 |        21         30 |        51 
           |     41.18      58.82 |    100.00 
-----------+----------------------+----------
     Total |        56         77 |       133 
           |     42.11      57.89 |    100.00 


+--------------------------------------------------------------------------------+

PARTICIPATION IN WAVE 1 ACTIVITIES

+--------------------------------------------------------------------------------+

tab wave1_participation endline_refusal, row


Participat |
 ed in any |
    wave 1 |    endline_refusal
  activity |         0          1 |     Total
-----------+----------------------+----------
         0 |       111         27 |       138 
           |     80.43      19.57 |    100.00 
-----------+----------------------+----------
         1 |       235         23 |       258 
           |     91.09       8.91 |    100.00 
-----------+----------------------+----------
     Total |       346         50 |       396 
           |     87.37      12.63 |    100.00 

. 


tab endline_refusal wave1_mc_b   

           |    Wave 1:Attended
endline_re |      Masterclass
     fusal | Not Atten   Attended |     Total
-----------+----------------------+----------
         0 |       112        234 |       346 
         1 |        27         23 |        50 
-----------+----------------------+----------
     Total |       139        257 |       396 

tab endline_refusal wave1_bt_b

           |    Wave 1:Attended
endline_re |       Bootcamp
     fusal | Not Atten   Attended |     Total
-----------+----------------------+----------
         0 |       198        148 |       346 
         1 |        41          9 |        50 
-----------+----------------------+----------
     Total |       239        157 |       396 

tab endline_refusal wave1_mt_b

           |   Wave 1:Registered
endline_re |       Mentoring
     fusal | Not Atten   Attended |     Total
-----------+----------------------+----------
         0 |       312         34 |       346 
         1 |        49          1 |        50 
-----------+----------------------+----------
     Total |       361         35 |       396 


+--------------------------------------------------------------------------------+

PARTICIPATION IN WAVE 2 ACTIVITIES

+--------------------------------------------------------------------------------+

tab wave2_participation endline_refusal, row

Participat |
 ed in any |
    wave 2 |    endline_refusal
  activity |         0          1 |     Total
-----------+----------------------+----------
         0 |       110         25 |       135 
           |     81.48      18.52 |    100.00 
-----------+----------------------+----------
         1 |       175          7 |       182 
           |     96.15       3.85 |    100.00 
-----------+----------------------+----------
     Total |       285         32 |       317 
           |     89.91      10.09 |    100.00 


tab endline_refusal wave2_mc_b

           |    Wave 2:Attended
endline_re |      Masterclass
     fusal |         0          1 |     Total
-----------+----------------------+----------
         0 |       110        175 |       285 
         1 |        25          7 |        32 
-----------+----------------------+----------
     Total |       135        182 |       317 


 tab endline_refusal wave2_bt_b

           |    Wave 2:Attended
endline_re |       Bootcamp
     fusal |         0          1 |     Total
-----------+----------------------+----------
         0 |       162        123 |       285 
         1 |        30          2 |        32 
-----------+----------------------+----------
     Total |       192        125 |       317 


tab endline_refusal wave2_mt_accepted_b  // Note: wave 2 mentorship is still ongoing and hence cannot get attendance numbers 

           |    Wave 2:Accepted
endline_re |      Mentorship
     fusal |         0          1 |     Total
-----------+----------------------+----------
         0 |       238         47 |       285 
         1 |        31          1 |        32 
-----------+----------------------+----------
     Total |       269         48 |       317 


